﻿CREATE PROCEDURE [dbo].[ContactDetail_Update]
@ContactDetailID uniqueidentifier
, @ModifiedBy uniqueidentifier
, @HomeNumber varchar (24)
, @MobileNumber varchar (24)
, @WorkNumber varchar (24)
, @FaxNumber varchar (24)
, @EmailAddress varchar (128)
AS
BEGIN

UPDATE [dbo].[ContactDetail]
SET  [ModifiedBy] = @ModifiedBy
, [HomeNumber] = @HomeNumber
, [MobileNumber] = @MobileNumber
, [WorkNumber] = @WorkNumber
, [FaxNumber] = @FaxNumber
, [EmailAddress] = @EmailAddress
, [ModifiedDate] = GETDATE()
WHERE [Deleted] = 0
AND [ContactDetailID] = @ContactDetailID


END
